Overview

The following document provides an initial descriptive analysis and data coverage overview of the [Annual Survey of State and Local Government Finances. The data is provided in a standardised format from Willamette University. The data is available at a county level between 1967 - 2020 with improved coverage in more recent years. The below data overview incorporates only data from 2001-2020 (can be expanded easily). The data has been cleaned and grouped into 17 expenditure categories (listed in data tree below), 4 higher-level categories (comprised of the 17 lower-level categories), and as a county-level total expenditure. All plots are presented using the raw data, whereas the tables presenting the linear time trend results include results for both the raw data and linearly interpolated data.

Expenditure categories

The data is currently structured in county-year pairs with observations for 17 public expenditure categories. I have manually grouped these 17 categories into 4 higher categories (that can be changed/redefined easily!). The tree structure below displays all categories and groupings. As currently thought out, any or a combination of these categories will serve as outcome/dependent variables.

##                                     levelName
## 1  Total Public Expenditure                  
## 2   ¦--Commercial                            
## 3   ¦   ¦--Air Transportation                
## 4   ¦   ¦--Liquor Stores                     
## 5   ¦   °--Port Facilities                   
## 6   ¦--Public Welfare, Services & Facilities 
## 7   ¦   ¦--Education                         
## 8   ¦   ¦--Fire Protection                   
## 9   ¦   ¦--Health & Hospitals                
## 10  ¦   ¦--Housing & Community Development   
## 11  ¦   ¦--Public Services & Facilities      
## 12  ¦   ¦--Public Transit                    
## 13  ¦   ¦--Public Welfare                    
## 14  ¦   °--Retirement                        
## 15  ¦--Administration & Misc.                
## 16  ¦   ¦--General Administration            
## 17  ¦   ¦--Interest on Debt                  
## 18  ¦   °--NEC                               
## 19  °--Infrastructure, Utilities & Regulation
## 20      ¦--Highways                          
## 21      ¦--Police, Corrections & Judicial    
## 22      ¦--Protective Inspection & Regulation
## 23      ¦--Utilities                         
## 24      °--Waste Management & Sewerage

Overview Plots

The below plots provide aggregated geographical (national, state, regional) summaries of expenditure categories and shares to demonstrate the composition of national expenditure across the categories. The final two plots demonstrate the composition of expenditure within the Public Welfare, Services & Facilities category.

Data Coverage

Geography - Broad Categories and Total Expenditure

The animations below show the data coverage at a county level of the 4 broad categories (purple) and total expenditure values (green). Coverage is strong at this level. (Apologies for the poor arrangement!)

Time - Missing Data

## [1] 58102

A tibble: 1 × 8

administration_misc_tot commercial_tot infrastructure_utilities_regulation_tot 1 0 0 0 # ℹ 5 more variables: public_welfare_services_facilities_tot , # administration_misc_pc , commercial_pc , # infrastructure_utilities_regulation_pc , # public_welfare_services_facilities_pc # A tibble: 1 × 8 administration_misc_tot commercial_tot infrastructure_utilities_regulation_tot 1 0 0 0 # ℹ 5 more variables: public_welfare_services_facilities_tot , # administration_misc_pc , commercial_pc , # infrastructure_utilities_regulation_pc , # public_welfare_services_facilities_pc
Expenditure (levels)
Expenditure (per capita)
Outcome Variable
  1. Raw Data
  1. Lin. Interpol.
  1. Raw Data
  1. Lin. Interpol.
Commercial 33.61*** 37.65*** 0*** 0***
1.63 1.63 0 0
Administration Misc 461.43*** 501.24*** 0*** 0***
4.9 4.88 0 0
Infrastructure Utilities Regulation 885.02*** 957.29*** 0*** 0***
10.53 10.49 0 0
Public Welfare Services Facilities 1566.59*** 1659.56*** 0*** 0***
24.49 24.44 0 0

Across Granular Expenditure Categories (17)

Expenditure (levels)
Expenditure (per capita)
Outcome Variable
  1. Raw Data
  1. Lin. Interpol.
  1. Raw Data
  1. Lin. Interpol.
Public Transit -0.81. 7.16*** 0 0***
0.46 0.38 0 0
Port Facilities 4.73*** 2.73*** 0*** 0***
0.37 0.22 0 0
Liquor Stores 6.56*** 4.16*** 0*** 0***
0.4 0.27 0 0
Protective Inspection Regulation 12.29*** 9.62*** 0*** 0***
0.21 0.15 0 0
Air Transportation 39.35*** 35.07*** 0*** 0***
2.11 1.54 0 0
Housing Community Development 50.21*** 35.64*** 0*** 0***
1.33 0.91 0 0
Retirement 78.28*** 88.2*** 0*** 0***
4.6 3.63 0 0
Fire Protection 89.41*** 63.67*** 0*** 0***
2.34 1.61 0 0
Utilities 122.05*** 81.12*** 0*** 0***
3.21 2.05 0 0
Interest On Debt 141.53*** 99.57*** 0*** 0***
2.62 1.82 0 0
Waste Management Sewerage 154.54*** 109.59*** 0*** 0***
2.6 1.8 0 0
General Administration 175.9*** 131.49*** 0*** 0***
1.58 1.1 0 0
Public Services Facilities 218.09*** 155.71*** 0*** 0***
3.13 2.17 0 0
Highways 230.94*** 177.21*** 0*** 0***
2.33 1.62 0 0
Nec 374.44*** 273.48*** 0*** 0***
4.37 3.04 0 0
Public Welfare 434.72*** 307.85*** 0*** 0***
9.61 6.64 0 0
Education 654.92*** 467.84*** 0*** 0***
11.05 7.65 0 0
Police Corrections Judicial 806.11*** 578.78*** 0.01*** 0.01***
10.36 7.18 0 0
Health Hospitals 838.21*** 587.63*** 0.01*** 0.01***
16.54 11.44 0 0

Preliminary Analysis

Factor Analysis

Spatial Analysis